Release 10.1A: OpenEdge Development:
Internationalizing Applications

Converting an OpenEdge database to UTF-8 using dump and load

To convert an OpenEdge database to UTF-8 using the dump and load utilities:

Caution: Before beginning, back up your database.

Caution: Do not use binary dump and load.

Dump the schema and data of the existing database using the Data Administration utility.
(From the Procedure Editor main menu, select Tools Data Administration Admin Dump Data and Definitions.)
Create a new, empty UTF-8 database using the syntax for your operating system:

Windows syntax	prodb database-name %DLC%\prolang\utf\empty.db
UNIX syntax	prodb database-name $DLC/prolang/utf/empty.db

Note: OpenEdge loads the UTF-8 BASIC collation (the _tran.df collation data definition file) in the empty UTF-8 database automatically and by default.
If you want to use an International Components for Unicode (ICU) collation, load the collation data definition (.df) file using the syntax for your operating system:

Windows syntax	%DLC%\prolang\utf\filename.df
UNIX syntax	$DLC/prolang/utf/filename.df

ICU collation data definition files are prefixed with “ICU” (such as ICU-cs.df used for Czech databases).

Compile, store, and apply the UTF-8 word-break rules to the database. For complete instructions, see the "Compiling, storing, and applying the UTF-8 word-break rules to a database" section.
Load the schema and data to the database using the Data Administration utility.
(From the Procedure Editor main menu, select Tools Data Administration Admin Load Data and Definitions.)
Note: When the data are loaded, the indexes are automatically rebuilt.